Global Shipments Data

Introduction

This is our R Notebook, showing the steps we took to complete the Final Project for CS 329E. This notebook includes step-by-step instructions on how to reproduce our project. To obtain our data, we used data.world.

R Configuration

Below we display our sessionInfo().

sessionInfo(package=NULL)

Data Description

The data was found on “Dr. John Rasp’s Statistics Website” (http://www2.stetson.edu/~jrasp/data.htm). It is a subset of the data from College Scorecard, a Department of Education website that gives data on various variables regarding tuition, costs and school performance.

Cleaning Data

Here’s our ETL file to clean our data set.

source("../01 Data/R_ETL.CollegeScorecard.R")

Cleaned up Data Download

Cleaned data can be downloaded from Data.world as a .csv file. Because the dataset is so large, we filtered to only show some rows.

Hosting User: jlee
Database: S17 DV Final Project
Dataset Name: CollegeScorecard.csv

Download Link: https://query.data.world/s/dv5dl8q1jx2qb3d3bd2976b9d

source("../01 Data/Accessdataworld.R")

Side by Side Shiny and Tableau Visualizations

Descriptions: Refer to visualization captions for individual descriptions.

Boxplot: Average Cost of Attendance for Type of School

These boxplots (Tableau left, Shiny right) dfddf

Histogram: SAT Averages for Universities

These histograms (Tableau left, Shiny right) dfddf

Scatterplot: Instructional Expenditures vs. Net tuition

These scatterplots (Tableau left, Shiny right) explore the correlation between Instructional expenditures per full-time equivalent student and Net tuition revenue per full-time equivalent student.

Crosstab 1: BLABLALBLA

These crosstabs (Tableau left, Shiny right) xxxx

Crosstab 2: BLABLALBLA

These crosstabs (Tableau left, Shiny right) xxxx

Map 1: BLABLALBLA

These maps (Tableau left, Shiny right) xxxx

Map 2: BLABLALBLA

These maps (Tableau left, Shiny right) xxxx

Barchart: BLABLALBLA

These barcharts (Tableau left, Shiny right) xxxx

Tableau / Tableau Action Generated Visualizations

Descriptions: Full size static .pngs of the tableau visualizations. Refer to visualization captions for individual descriptions.

Tableau generated barcharts.

Tableau generated ID sets.

Shiny Visualization and Published Application

Description: Full size static .pngs of the Shiny application, as well as a link to the live published version.

Published Link:
https://frannyfang.shinyapps.io/Barchart1/

Barchart1